package com.scuec.trainingmanagementsys.service;

import com.scuec.trainingmanagementsys.entity.Student;

import java.util.List;
import java.util.Map;

public interface StudentService {
    // 整表查询
    List<Student> getAllStudents();

    // 根据学号查询
    Student getStudentByNumber(String studentNumber);

    // 根据姓名模糊查询
    List<Student> getStudentsByName(String studentName);

    // 根据性别查询
    List<Student> getStudentsByGender(String gender);

    // 根据学院查询
    List<Student> getStudentsByCollege(String college);

    // 多条件查询
    List<Student> getStudentsByConditions(String studentNumber, String studentName, String gender, String college);

    // 删除功能
    int deleteStudentByNumber(String studentNumber);

    // 修改信息功能
    int updateStudent(Student student);

    // 插入信息功能
    int insertStudent(Student student);

    // 多选删除功能
    int deleteStudentsByNumbers(List<String> studentNumbers);

    // 根据学号和密码查询学生
    Student getStudentByNumberAndPassword(String studentNumber, String studentPassword);
    // 获取学生完整资料
    Student getStudentProfile(String studentNumber);

    int getStudentCount();


}